
if exists(select name from sysobjects where name = 'sp_UserDangNhap')
	drop proc sp_UserDangNhap
go
/*
	Created by: Phuoc NH
	Created on: 13/05/2013 (dd/mm/yyyy)
	Description: 
	--

	File:$sql-scripts/Proc.sp_UserDangNhap.sql
*/

create proc sp_UserDangNhap
@UserName varchar(50),
@Pass varchar(100)
as
begin
	select * from Users where Username=@username and pass=@pass and TrangThai<>'0'-- and NhomUserId=1
end

